# coding: utf-8
from common.models.user import User
from application import db


class BookIndex(db.Model):
    __tablename__ = 'book_index'

    id = db.Column(db.Integer, primary_key=True)
    sn = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    projectname = db.Column(db.String(50, 'utf8mb4_0900_ai_ci'))
    gcname = db.Column(db.String(50, 'utf8mb4_0900_ai_ci'))
    bname = db.Column(db.String(50, 'utf8mb4_0900_ai_ci'))
    type = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    num = db.Column(db.String(50, 'utf8mb4_0900_ai_ci'))
    mark = db.Column(db.Integer)
    updated_time = db.Column(db.DateTime)
    created_time = db.Column(db.DateTime)
    uid = db.Column(db.Integer)
    company = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    isover = db.Column(db.String(10, 'utf8mb4_0900_ai_ci'))
    dbtime = db.Column(db.Date)
    zjzb = db.Column(db.String(50, 'utf8mb4_0900_ai_ci'))
    special = db.Column(db.String(50, 'utf8mb4_0900_ai_ci'))



